Configuring the task template and parameters: SQL Server

This section discusses how to configure the task template and parameters for SQL Server. For information on how to configure the task template and parameters for Oracle, see Configuring the task template and parameters: Oracle.

The Active Storage Manager installation process creates a new task type, template, and parameters in the IEE Task Management subsystem.

Important! Active Storage Manager only supports using the DefaultActiveStorageManager template. Do not create any additional templates for Active Storage Manager.

  1. Go to System Operations > Task Management > Task Templates.

  2. From the Task Type dropdown menu, select Active Storage Manager. The Task Template field will automatically populate to DefaultActiveStorageManager.

  3. Complete the fields in the Storage Tier 1, 2, and 3 sections as follows:

    Table 80 Active Storage Manager Parameters

    Parameter Name

    Description

    Required

    Allowed Values

    Storage Tier 1

    Name

    A short name which identifies this tier.

    Yes

    Any alphanumeric string 100 characters or less.

    Retention Months

    Number of months to retain data on this tier.

    Yes

    An integer > 0.

    Storage Tier 2

    Name

    A short name which identifies this tier.

    Yes

    Any alphanumeric string 100 characters or less.

    Suffix Appended to Tier 1 Data Area

    A short tag to be appended to the base data area (tablespace / filegroup) name.

    Yes

    Any combination of letters, numbers, or underscores. Length is only limited by the platform dependent maximum length of a data area name .

    Retention Months

    Number of months to retain data on this tier.

    Required only if Storage Tier 3 is configured.

    An integer > 0.

    Compression Level

    The level of compression which should be applied when moving data onto this storage tier.

    No

    Page, Row, None (default is Page) .

    The specific compression methods for each of these levels varies depending on platform. See note below.

    Tier-2 Location

    Specify the storage location for Tier-2 to hold the moved file within the same file group.

    Yes

    Specify the physical path or the network location of the storage.

    Storage Tier 3

    Name

    A short name which identifies this tier.

    Required if the remaining Storage Tier 3 parameters are specified.

    Any alphanumeric string 100 characters or less.

    Suffix Appended to Tier-2 Data Area

    A short tag to be appended to the base data area (tablespace / filegroup) name.

    Required if Storage Tier 3 Name is configured

    Any combination of letters, numbers, or underscores. Length is only limited by the platform dependent maximum length of a data area name .

    Compression Level

    The level of compression which should be applied when moving data onto this storage tier.

    No

    Page, Row, None (default is Page) .

    The specific compression methods for each of these levels varies depending on platform. See note below.

    Tier-3 Location

    Specify the storage location for Tier-3 to hold the moved file within the same file group.

    Yes

    Specify the physical path or the network location of the storage.

    Command Timeout (in seconds)

    Time to run the Active Storage Manager task.

    Yes

    Time in seconds.

    Note: The compression level values are configured for the following SQL Server-specific compression clauses.

    Table 81 SQL Server-specific Compression Clauses

    Parameter Value

    Compression Clause

    Row

    Helps to store data more efficiently in a row by storing fixed-length data types in variable-length storage format.

    Page

    Superset of row compression. In addition, optimizes storage of multiple rows in a page, by minimizing the data redundancy.

    None

    n/a

    Configuring the task template and parameters for SQL Server.

  4. Click Save.